SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW dbo.vwrSTecnicos
AS
SELECT     IDTecnico AS ID, ApellidoyNombre AS Descripcion
FROM         dbo.Tb_STecnicos

GO
GRANT SELECT ON  [dbo].[vwrSTecnicos] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vwrSTecnicos] TO [Informatica]
GRANT SELECT ON  [dbo].[vwrSTecnicos] TO [SoloVer]
GRANT SELECT ON  [dbo].[vwrSTecnicos] TO [Soporte]
GO
